package com.lrkj.common.core.controller;

import java.beans.PropertyEditorSupport;
import java.util.Date;
import java.util.List;
import java.util.Map;

import com.alibaba.fastjson.JSONArray;
import com.lrkj.common.constant.Constants;
import com.lrkj.common.constant.HttpStatus;
import com.lrkj.common.core.domain.OrderParam;
import com.lrkj.common.core.domain.SuperQuery;
import com.lrkj.common.utils.CommonUtils;
import com.lrkj.common.utils.DateUtils;
import com.lrkj.common.utils.StringUtils;
import com.lrkj.common.utils.sql.SqlUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.web.bind.WebDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.lrkj.common.core.domain.AjaxResult;
import com.lrkj.common.core.page.PageDomain;
import com.lrkj.common.core.page.TableDataInfo;
import com.lrkj.common.core.page.TableSupport;

/**
 * web层通用数据处理
 *
 * @author lrkj
 */
public class BaseController
{
    protected final Logger logger = LoggerFactory.getLogger(this.getClass());

    /**
     * 将前台传递过来的日期格式的字符串，自动转化为Date类型
     */
    @InitBinder
    public void initBinder(WebDataBinder binder)
    {
        // Date 类型转换
        binder.registerCustomEditor(Date.class, new PropertyEditorSupport()
        {
            @Override
            public void setAsText(String text)
            {
                setValue(DateUtils.parseDate(text));
            }
        });
    }

    /**
     * 设置请求分页数据
     */
    protected void startPage()
    {
        PageDomain pageDomain = TableSupport.buildPageRequest();
        Integer pageNum = pageDomain.getPageNum();
        Integer pageSize = pageDomain.getPageSize();
        if (StringUtils.isNotNull(pageNum) && StringUtils.isNotNull(pageSize))
        {
            String orderBy = SqlUtil.escapeOrderBySql(pageDomain.getOrderBy());
            PageHelper.startPage(pageNum, pageSize, orderBy);
        }
    }

    /**
     * 设置请求排序数据
     */
    protected void startOrderBy()
    {
        PageDomain pageDomain = TableSupport.buildPageRequest();
        if (StringUtils.isNotEmpty(pageDomain.getOrderBy()))
        {
            String orderBy = SqlUtil.escapeOrderBySql(pageDomain.getOrderBy());
            PageHelper.orderBy(orderBy);
        }
    }

    /**
     * 响应请求分页数据
     */
    @SuppressWarnings({ "rawtypes", "unchecked" })
    protected TableDataInfo getDataTable(List<?> list)
    {
        TableDataInfo rspData = new TableDataInfo();
        rspData.setCode(HttpStatus.SUCCESS);
        rspData.setMsg("查询成功");
        rspData.setRows(list);
        rspData.setTotal(new PageInfo(list).getTotal());
        return rspData;
    }

    /**
     * 响应返回结果
     *
     * @param rows 影响行数
     * @return 操作结果
     */
    protected AjaxResult toAjax(int rows)
    {
        return rows > 0 ? AjaxResult.success() : AjaxResult.error();
    }

    /**
     * 响应返回结果
     *
     * @param result 结果
     * @return 操作结果
     */
    protected AjaxResult toAjax(boolean result)
    {
        return result ? success() : error();
    }

    /**
     * 返回成功
     */
    public AjaxResult success()
    {
        return AjaxResult.success();
    }

    /**
     * 返回失败消息
     */
    public AjaxResult error()
    {
        return AjaxResult.error();
    }

    /**
     * 返回成功消息
     */
    public AjaxResult success(String message)
    {
        return AjaxResult.success(message);
    }

    /**
     * 返回失败消息
     */
    public AjaxResult error(String message)
    {
        return AjaxResult.error(message);
    }

    /**
     * 页面跳转
     */
    public String redirect(String url)
    {
        return StringUtils.format("redirect:{}", url);
    }

    /**
     * 自定义参数
     **/
    protected void changeParameter(Map<String, Object> params) {
        this.putCustomQuery(params);
        this.putOrderParam(params);
    }

    private void putCustomQuery(Map<String, Object> params){
        StringBuffer buffer = new StringBuffer();
        if (null != params && params.containsKey("searchQuery")) {
            List<SuperQuery> superQueries = JSONArray.parseArray(params.get("searchQuery").toString(), SuperQuery.class);

            superQueries.stream().forEach(x -> {
                if (StringUtils.isNotEmpty(x.getValue())) {
                    String propName = CommonUtils.humpToLine(x.getPropName());
                    buffer.append("  " + x.getMatchType() + " ");
                    if (x.getQueryType().equals(Constants.condition_type_IN)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" in ( " + CommonUtils.handleInParam(x.getValue()) + ") ");
                    } else if (x.getQueryType().equals(Constants.condition_type_EQ)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" = " + "'" + x.getValue() + "'");
                    } else if (x.getQueryType().equals(Constants.condition_type_NE)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" != " + "'" + x.getValue() + "'");
                    } else if (x.getQueryType().equals(Constants.condition_type_GT)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" > " + x.getValue());
                    } else if (x.getQueryType().equals(Constants.condition_type_GTE)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" >= " + x.getValue());
                    } else if (x.getQueryType().equals(Constants.condition_type_LT)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" < " + x.getValue());
                    } else if (x.getQueryType().equals(Constants.condition_type_LTE)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" <= " + x.getValue());
                    } else if (x.getQueryType().equals(Constants.condition_type_LIKE)) {
                        buffer.append(x.getAlias() + "." + propName);
                        buffer.append(" like '%" + x.getValue() + "%' ");
                    } else if (x.getQueryType().equals(Constants.condition_type_BETWEEN)) {

                    }
                }
            });
        }
        params.put("customQuery", buffer.toString());
    }

    public void putOrderParam(Map<String, Object> params){
        StringBuffer buffer = new StringBuffer();
        if (null != params && params.containsKey("orderParam")) {
            List<OrderParam> orderParams = JSONArray.parseArray(params.get("orderParam").toString(), OrderParam.class);
            if(orderParams.size() > 0){
                buffer.append("order by ");
                orderParams.stream().forEach(x->{
                    buffer.append(x.getAlias()+".");
                    buffer.append(x.getKey() +" ");
                    buffer.append(x.getOrder() + ",");
                });
            }
            if(buffer.length() > 0){
                buffer.deleteCharAt(buffer.length() -1);
            }
        }
        params.put("orderParam", buffer.toString());
    }
}
